123456/H5 2324/leerlingdetails.php

<?php include('db.php'); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Leerling</title> </head> <body> <?php $llnr = $_GET['llnr']; //ophalen uit het adres ?llnr= .... $query = "select * from leerlingen where llnr = $llnr order by achternaam "; $result = mysqli_query($db, $query); $row = mysqli_fetch_array($result); echo "<h2>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</h2>"; $row['geb_datum'] = strftime("%d %B %Y", strtotime($row['geb_datum'])); echo "<p>Klas $row[klas], $row[plaats] $row[postcode] $row[geb_datum]</p>"; $query = "select * from auteurs a, boeken b, uitleningen u where a.auteurnr = b.auteurnr and b.boeknr = u.boeknr and u.llnr = $llnr"; $result = mysqli_query($db, $query); while($row = mysqli_fetch_array($result)){ $row['datum_uit'] = strftime("%d %B %Y", strtotime($row['datum_uit'])); echo "<div><a href='boekdetails.php?boeknr=$row[boeknr]'>$row[titel]</a>, <a href='auteurdetails.php?auteurnr=$row[auteurnr]'>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</a>($row[datum_uit])</div>\n"; } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse